package com.mbc.rmt.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.mbc.rmt.data.OpeningAgentDataList;
import com.mbc.rmt.entities.AgentBalance;
import com.mbc.rmt.entities.OpeningAgent;
import com.mbc.rmt.entities.OpeningAgentRpt;

public interface OpeningAgentDAO {

	public void create(OpeningAgent entity) throws SQLException;

	public void update(OpeningAgent entity) throws SQLException;

	public void delete(long key) throws SQLException;

	public OpeningAgent find(long key) throws SQLException;

	public OpeningAgent findByCode(String code,long branchId)
			throws SQLException;

	public List<OpeningAgent> findAll() throws SQLException;

	public OpeningAgentDataList findOpeningAgents(OpeningAgent cri)
			throws SQLException;
	
	public OpeningAgent getOpeningAgent(long key) throws SQLException;
	
	public ArrayList<AgentBalance> getAgentBalance(long agent_id) throws SQLException;
	
	ResultSet prepareOpeningAgentReport(OpeningAgentRpt info) throws SQLException;
}
